How to access stdClass variables stdClass Object([max(id)])=>64)
Posted
by Theopile
on Stack Overflow
See other posts from Stack Overflow
or by Theopile
Published on 2010-06-12T15:17:54Z
Indexed on
2010/06/12
15:22 UTC
Read the original article
Hit count: 331
I need the very last valid entry in a database table which would be the row with the greatest primary key. So using mysqli, my query is "SELECT MAX(id) FROM table LIMIT 1". This query returns the correct number(using print_r()) but I cannot figure out how to access it. Here is the main code. Note that the $this->link refers to class with a mysqli connection.
$q="select max(id) from stones limit 1";
$qed=$this->link->query($q) or die(mysqli_error());
if($qed){
$row=$qed->fetch_object();
print_r($row);
echo $lastid=$row;//here is the problem
}
The valid line print_r($row) echos out "stdClass Object ( [max(id)] => 68 )"
© Stack Overflow or respective owner